Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	5201393
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	515.9 MiB
Average record size in memory	104.0 B

Variable types

Categorical	1
Numeric	11

Alerts

`DATEUTC` has a high cardinality: 52560 distinct values	High cardinality
`LC_HUMIDITY` is highly overall correlated with `LC_RAD` and 2 other fields	High correlation
`LC_DWPTEMP` is highly overall correlated with `LC_TEMP`	High correlation
`LC_RAD` is highly overall correlated with `LC_HUMIDITY` and 1 other fields	High correlation
`LC_RAD60` is highly overall correlated with `LC_HUMIDITY` and 2 other fields	High correlation
`LC_TEMP` is highly overall correlated with `LC_HUMIDITY` and 2 other fields	High correlation
`LC_RAININ` is highly skewed (γ1 = 47.01423082)	Skewed
`DATEUTC` is uniformly distributed	Uniform
`LC_RAD` has 2599146 (50.0%) zeros	Zeros
`LC_RAININ` has 5038773 (96.9%) zeros	Zeros
`LC_DAILYRAIN` has 4309199 (82.8%) zeros	Zeros
`LC_WINDDIR` has 2009326 (38.6%) zeros	Zeros
`LC_WINDSPEED` has 2108572 (40.5%) zeros	Zeros
`LC_RAD60` has 2511732 (48.3%) zeros	Zeros

Reproduction

Analysis started	2023-04-24 15:57:20.528655
Analysis finished	2023-04-24 15:58:54.757752
Duration	1 minute and 34.23 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

DATEUTC
Categorical

HIGH CARDINALITY UNIFORM

Distinct	52560
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	79.4 MiB

2022-09-02 15:40:00	108
2022-09-02 09:30:00	108
2022-09-01 04:00:00	108
2022-09-01 05:10:00	108
2022-09-01 05:20:00	108
Other values (52555)	5200853

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	98826467
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2022-01-01 00:10:00
2nd row	2022-01-01 00:20:00
3rd row	2022-01-01 00:30:00
4th row	2022-01-01 00:40:00
5th row	2022-01-01 00:50:00

Common Values

Value	Count	Frequency (%)
2022-09-02 15:40:00	108	< 0.1%
2022-09-02 09:30:00	108	< 0.1%
2022-09-01 04:00:00	108	< 0.1%
2022-09-01 05:10:00	108	< 0.1%
2022-09-01 05:20:00	108	< 0.1%
2022-09-01 05:30:00	108	< 0.1%
2022-09-01 05:40:00	108	< 0.1%
2022-09-01 05:50:00	108	< 0.1%
2022-09-01 06:10:00	108	< 0.1%
2022-09-01 06:20:00	108	< 0.1%
Other values (52550)	5200313	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
17:20:00	36310	0.3%
17:10:00	36296	0.3%
17:00:00	36288	0.3%
19:00:00	36288	0.3%
18:50:00	36285	0.3%
16:50:00	36275	0.3%
16:40:00	36271	0.3%
17:30:00	36269	0.3%
07:20:00	36263	0.3%
07:10:00	36261	0.3%
Other values (500)	10039980	96.5%

Most occurring characters

Value	Count	Frequency (%)
0	30843261	31.2%
2	21008421	21.3%
-	10402786	10.5%
:	10402786	10.5%
1	8198089	8.3%
	5201393	5.3%
3	2706229	2.7%
5	2259823	2.3%
4	2215071	2.2%
8	1411809	1.4%
Other values (3)	4176799	4.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	72819502	73.7%
Dash Punctuation	10402786	10.5%
Other Punctuation	10402786	10.5%
Space Separator	5201393	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	30843261	42.4%
2	21008421	28.8%
1	8198089	11.3%
3	2706229	3.7%
5	2259823	3.1%
4	2215071	3.0%
8	1411809	1.9%
7	1407574	1.9%
6	1384659	1.9%
9	1384566	1.9%

Dash Punctuation

Value	Count	Frequency (%)
-	10402786	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	10402786	100.0%

Space Separator

Value	Count	Frequency (%)
	5201393	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	98826467	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	30843261	31.2%
2	21008421	21.3%
-	10402786	10.5%
:	10402786	10.5%
1	8198089	8.3%
	5201393	5.3%
3	2706229	2.7%
5	2259823	2.3%
4	2215071	2.2%
8	1411809	1.4%
Other values (3)	4176799	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	98826467	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	30843261	31.2%
2	21008421	21.3%
-	10402786	10.5%
:	10402786	10.5%
1	8198089	8.3%
	5201393	5.3%
3	2706229	2.7%
5	2259823	2.3%
4	2215071	2.2%
8	1411809	1.4%
Other values (3)	4176799	4.2%

ID
Real number (ℝ)

Distinct	108
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	72.338427

Minimum	2
Maximum	138
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	79.4 MiB

Quantile statistics

Minimum	2
5-th percentile	8
Q1	42
median	74
Q3	108
95-th percentile	130
Maximum	138
Range	136
Interquartile range (IQR)	66

Descriptive statistics

Standard deviation	39.500699
Coefficient of variation (CV)	0.54605416
Kurtosis	-1.1678772
Mean	72.338427
Median Absolute Deviation (MAD)	34
Skewness	-0.13783482
Sum	3.7626059 × 10⁸
Variance	1560.3052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122	52544	1.0%
123	52542	1.0%
22	52540	1.0%
111	52539	1.0%
124	52537	1.0%
19	52535	1.0%
112	52533	1.0%
117	52519	1.0%
80	52519	1.0%
105	52500	1.0%
Other values (98)	4676085	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	51359	1.0%
3	50285	1.0%
4	49875	1.0%
5	48084	0.9%
6	49191	0.9%
8	37594	0.7%
9	52403	1.0%
10	48086	0.9%
11	42811	0.8%
12	48512	0.9%

Value	Count	Frequency (%)
138	22670	0.4%
137	30406	0.6%
136	30142	0.6%
135	26823	0.5%
134	26229	0.5%
133	33364	0.6%
132	33909	0.7%
131	33865	0.7%
130	33866	0.7%
129	33911	0.7%

LC_HUMIDITY
Real number (ℝ)

Distinct	88
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.626124

Minimum	12
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	79.4 MiB

Quantile statistics

Minimum	12
5-th percentile	41
Q1	64
median	82
Q3	92
95-th percentile	99
Maximum	99
Range	87
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	18.527435
Coefficient of variation (CV)	0.24179006
Kurtosis	-0.4223342
Mean	76.626124
Median Absolute Deviation (MAD)	12
Skewness	-0.74815239
Sum	3.9856258 × 10⁸
Variance	343.26587
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	330235	6.3%
96	159521	3.1%
95	157470	3.0%
94	155972	3.0%
97	152718	2.9%
93	149949	2.9%
92	147093	2.8%
91	140775	2.7%
90	140261	2.7%
98	137285	2.6%
Other values (78)	3530114	67.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	1	< 0.1%
13	40	< 0.1%
14	211	< 0.1%
15	445	< 0.1%
16	648	< 0.1%
17	656	< 0.1%
18	675	< 0.1%
19	706	< 0.1%
20	1070	< 0.1%
21	1480	< 0.1%

Value	Count	Frequency (%)
99	330235	6.3%
98	137285	2.6%
97	152718	2.9%
96	159521	3.1%
95	157470	3.0%
94	155972	3.0%
93	149949	2.9%
92	147093	2.8%
91	140775	2.7%
90	140261	2.7%

LC_DWPTEMP
Real number (ℝ)

Distinct	3505
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.1473083

Minimum	-12.6
Maximum	25.78
Zeros	4415
Zeros (%)	0.1%
Negative	430919
Negative (%)	8.3%
Memory size	79.4 MiB

Quantile statistics

Minimum	-12.6
5-th percentile	-1.45
Q1	4.25
median	8.76
Q3	12.28
95-th percentile	16.27
Maximum	25.78
Range	38.38
Interquartile range (IQR)	8.03

Descriptive statistics

Standard deviation	5.4547058
Coefficient of variation (CV)	0.66951017
Kurtosis	-0.40094307
Mean	8.1473083
Median Absolute Deviation (MAD)	3.96
Skewness	-0.37695549
Sum	42377352
Variance	29.753815
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.39	9706	0.2%
8.89	9562	0.2%
9.28	9312	0.2%
9.22	9196	0.2%
9.11	9183	0.2%
9.5	9112	0.2%
9.61	9060	0.2%
6.61	8616	0.2%
9.72	8572	0.2%
9.78	8570	0.2%
Other values (3495)	5110504	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-12.6	3	< 0.1%
-12.5	2	< 0.1%
-12.4	1	< 0.1%
-12.34	1	< 0.1%
-12.33	2	< 0.1%
-12.3	2	< 0.1%
-12.29	1	< 0.1%
-12.28	2	< 0.1%
-12.25	2	< 0.1%
-12.24	1	< 0.1%

Value	Count	Frequency (%)
25.78	1	< 0.1%
24.27	1	< 0.1%
24.22	1	< 0.1%
24.21	1	< 0.1%
24.17	1	< 0.1%
24.15	1	< 0.1%
23.89	1	< 0.1%
23.83	1	< 0.1%
23.8	1	< 0.1%
23.78	1	< 0.1%

LC_n
Real number (ℝ)

Distinct	47
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.386937

Minimum	1
Maximum	47
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	79.4 MiB

Quantile statistics

Minimum	1
5-th percentile	17
Q1	37
median	37
Q3	38
95-th percentile	38
Maximum	47
Range	46
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	6.6837961
Coefficient of variation (CV)	0.1888775
Kurtosis	12.8184
Mean	35.386937
Median Absolute Deviation (MAD)	1
Skewness	-3.6727055
Sum	1.8406137 × 10⁸
Variance	44.673131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
37	2136855	41.1%
38	2121990	40.8%
35	168433	3.2%
32	152223	2.9%
36	152160	2.9%
31	73838	1.4%
10	19816	0.4%
30	18849	0.4%
3	18618	0.4%
8	18373	0.4%
Other values (37)	320238	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11236	0.2%
2	18098	0.3%
3	18618	0.4%
4	17262	0.3%
5	17194	0.3%
6	16255	0.3%
7	16289	0.3%
8	18373	0.4%
9	16256	0.3%
10	19816	0.4%

Value	Count	Frequency (%)
47	4	< 0.1%
46	1	< 0.1%
45	7	< 0.1%
44	11	< 0.1%
43	15	< 0.1%
42	22	< 0.1%
41	28	< 0.1%
40	38	< 0.1%
39	3391	0.1%
38	2121990	40.8%

LC_RAD
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	915
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.441832

Minimum	0
Maximum	994
Zeros	2599146
Zeros (%)	50.0%
Negative	0
Negative (%)	0.0%
Memory size	79.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	85
95-th percentile	446
Maximum	994
Range	994
Interquartile range (IQR)	85

Descriptive statistics

Standard deviation	144.18438
Coefficient of variation (CV)	1.814968
Kurtosis	4.1875575
Mean	79.441832
Median Absolute Deviation (MAD)	1
Skewness	2.2014847
Sum	4.1320819 × 10⁸
Variance	20789.136
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2599146	50.0%
1	44587	0.9%
4	37275	0.7%
3	33305	0.6%
2	31764	0.6%
5	27346	0.5%
6	21887	0.4%
7	19965	0.4%
23	19301	0.4%
22	19278	0.4%
Other values (905)	2347539	45.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2599146	50.0%
1	44587	0.9%
2	31764	0.6%
3	33305	0.6%
4	37275	0.7%
5	27346	0.5%
6	21887	0.4%
7	19965	0.4%
8	18610	0.4%
9	17127	0.3%

Value	Count	Frequency (%)
994	1	< 0.1%
975	1	< 0.1%
950	1	< 0.1%
949	1	< 0.1%
948	2	< 0.1%
946	1	< 0.1%
932	2	< 0.1%
929	2	< 0.1%
927	1	< 0.1%
926	1	< 0.1%

LC_RAININ
Real number (ℝ)

SKEWED ZEROS

Distinct	109
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.00010329541

Minimum	0
Maximum	0.38
Zeros	5038773
Zeros (%)	96.9%
Negative	0
Negative (%)	0.0%
Memory size	79.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	0.38
Range	0.38
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.00099938377
Coefficient of variation (CV)	9.6750069
Kurtosis	8268.0203
Mean	0.00010329541
Median Absolute Deviation (MAD)	0
Skewness	47.014231
Sum	537.28
Variance	9.9876792 × 10^-7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5038773	96.9%
0.002	52394	1.0%
0.001	45502	0.9%
0.003	26050	0.5%
0.004	11383	0.2%
0.005	6730	0.1%
0.006	5039	0.1%
0.007	3241	0.1%
0.008	2394	< 0.1%
0.009	1670	< 0.1%
Other values (99)	8217	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5038773	96.9%
0.001	45502	0.9%
0.002	52394	1.0%
0.003	26050	0.5%
0.004	11383	0.2%
0.005	6730	0.1%
0.006	5039	0.1%
0.007	3241	0.1%
0.008	2394	< 0.1%
0.009	1670	< 0.1%

Value	Count	Frequency (%)
0.38	1	< 0.1%
0.335	1	< 0.1%
0.167	1	< 0.1%
0.141	2	< 0.1%
0.129	1	< 0.1%
0.123	1	< 0.1%
0.114	1	< 0.1%
0.111	1	< 0.1%
0.11	1	< 0.1%
0.109	1	< 0.1%

LC_DAILYRAIN
Real number (ℝ)

Distinct	143
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.001219403

Minimum	0
Maximum	0.154
Zeros	4309199
Zeros (%)	82.8%
Negative	0
Negative (%)	0.0%
Memory size	79.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.007
Maximum	0.154
Range	0.154
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.0051042783
Coefficient of variation (CV)	4.1858832
Kurtosis	337.45867
Mean	0.001219403
Median Absolute Deviation (MAD)	0
Skewness	14.211986
Sum	6342.594
Variance	2.6053657 × 10^-5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4309199	82.8%
0.002	180517	3.5%
0.001	117857	2.3%
0.003	81411	1.6%
0.004	80393	1.5%
0.007	72072	1.4%
0.005	60223	1.2%
0.006	53801	1.0%
0.008	36683	0.7%
0.009	28413	0.5%
Other values (133)	180824	3.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4309199	82.8%
0.001	117857	2.3%
0.002	180517	3.5%
0.003	81411	1.6%
0.004	80393	1.5%
0.005	60223	1.2%
0.006	53801	1.0%
0.007	72072	1.4%
0.008	36683	0.7%
0.009	28413	0.5%

Value	Count	Frequency (%)
0.154	5	< 0.1%
0.153	14	< 0.1%
0.152	92	< 0.1%
0.151	786	< 0.1%
0.15	114	< 0.1%
0.149	15	< 0.1%
0.148	10	< 0.1%
0.147	5	< 0.1%
0.146	13	< 0.1%
0.145	9	< 0.1%

LC_WINDDIR
Real number (ℝ)

Distinct	360
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-5.7668467

Minimum	-179
Maximum	180
Zeros	2009326
Zeros (%)	38.6%
Negative	1706282
Negative (%)	32.8%
Memory size	79.4 MiB

Quantile statistics

Minimum	-179
5-th percentile	-158
Q1	-56
median	0
Q3	28
95-th percentile	154
Maximum	180
Range	359
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	87.305095
Coefficient of variation (CV)	-15.139139
Kurtosis	-0.34495828
Mean	-5.7668467
Median Absolute Deviation (MAD)	41
Skewness	0.026819332
Sum	-29995636
Variance	7622.1797
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2009326	38.6%
-146	13718	0.3%
-144	13696	0.3%
-147	13694	0.3%
-145	13617	0.3%
-143	13548	0.3%
-148	13527	0.3%
-149	13376	0.3%
-142	13331	0.3%
-140	13291	0.3%
Other values (350)	3070269	59.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-179	10505	0.2%
-178	10710	0.2%
-177	10996	0.2%
-176	10885	0.2%
-175	11254	0.2%
-174	11275	0.2%
-173	11566	0.2%
-172	11784	0.2%
-171	11913	0.2%
-170	12017	0.2%

Value	Count	Frequency (%)
180	10536	0.2%
179	10309	0.2%
178	10151	0.2%
177	10039	0.2%
176	9800	0.2%
175	9720	0.2%
174	9610	0.2%
173	9679	0.2%
172	9692	0.2%
171	9596	0.2%

LC_WINDSPEED
Real number (ℝ)

Distinct	891
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.28588148

Minimum	0
Maximum	13.7
Zeros	2108572
Zeros (%)	40.5%
Negative	0
Negative (%)	0.0%
Memory size	79.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.04
Q3	0.31
95-th percentile	1.4
Maximum	13.7
Range	13.7
Interquartile range (IQR)	0.31

Descriptive statistics

Standard deviation	0.56425252
Coefficient of variation (CV)	1.9737288
Kurtosis	20.121346
Mean	0.28588148
Median Absolute Deviation (MAD)	0.04
Skewness	3.7003953
Sum	1486982
Variance	0.3183809
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2108572	40.5%
0.01	184266	3.5%
0.02	152146	2.9%
0.03	121551	2.3%
0.04	104820	2.0%
0.05	92702	1.8%
0.06	83655	1.6%
0.07	76216	1.5%
0.08	69690	1.3%
0.09	64808	1.2%
Other values (881)	2142967	41.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2108572	40.5%
0.01	184266	3.5%
0.02	152146	2.9%
0.03	121551	2.3%
0.04	104820	2.0%
0.05	92702	1.8%
0.06	83655	1.6%
0.07	76216	1.5%
0.08	69690	1.3%
0.09	64808	1.2%

Value	Count	Frequency (%)
13.7	1	< 0.1%
12.2	1	< 0.1%
12.15	1	< 0.1%
11.44	1	< 0.1%
11.21	1	< 0.1%
10.71	1	< 0.1%
10.62	1	< 0.1%
10.45	1	< 0.1%
10.42	1	< 0.1%
10.41	1	< 0.1%

LC_RAD60
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	861
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.430396

Minimum	0
Maximum	894
Zeros	2511732
Zeros (%)	48.3%
Negative	0
Negative (%)	0.0%
Memory size	79.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	88
95-th percentile	434
Maximum	894
Range	894
Interquartile range (IQR)	88

Descriptive statistics

Standard deviation	141.37496
Coefficient of variation (CV)	1.7798598
Kurtosis	3.8537509
Mean	79.430396
Median Absolute Deviation (MAD)	2
Skewness	2.1309413
Sum	4.131487 × 10⁸
Variance	19986.881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2511732	48.3%
1	81754	1.6%
2	49010	0.9%
3	41212	0.8%
4	39387	0.8%
5	26419	0.5%
6	22233	0.4%
7	20495	0.4%
8	18710	0.4%
25	18255	0.4%
Other values (851)	2372186	45.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2511732	48.3%
1	81754	1.6%
2	49010	0.9%
3	41212	0.8%
4	39387	0.8%
5	26419	0.5%
6	22233	0.4%
7	20495	0.4%
8	18710	0.4%
9	18201	0.3%

Value	Count	Frequency (%)
894	1	< 0.1%
878	1	< 0.1%
873	1	< 0.1%
870	1	< 0.1%
869	1	< 0.1%
865	1	< 0.1%
860	1	< 0.1%
859	1	< 0.1%
856	1	< 0.1%
855	1	< 0.1%

LC_TEMP
Real number (ℝ)

Distinct	4567782
Distinct (%)	87.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.606175

Minimum	-11.4
Maximum	42.161164
Zeros	0
Zeros (%)	0.0%
Negative	177244
Negative (%)	3.4%
Memory size	79.4 MiB

Quantile statistics

Minimum	-11.4
5-th percentile	1.0325705
Q1	7.387517
median	12.349102
Q3	17.66019
95-th percentile	25.004656
Maximum	42.161164
Range	53.561164
Interquartile range (IQR)	10.272673

Descriptive statistics

Standard deviation	7.3911548
Coefficient of variation (CV)	0.58631224
Kurtosis	-0.18548579
Mean	12.606175
Median Absolute Deviation (MAD)	5.1488284
Skewness	0.1501703
Sum	65569671
Variance	54.62917
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.8	1400	< 0.1%
10.2	1360	< 0.1%
11.9	1335	< 0.1%
10.3	1334	< 0.1%
10.9	1333	< 0.1%
13.3	1333	< 0.1%
13.4	1310	< 0.1%
11.3	1288	< 0.1%
13.6	1282	< 0.1%
10.1	1281	< 0.1%
Other values (4567772)	5188137	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-11.4	3	< 0.1%
-11.3	2	< 0.1%
-11.2	1	< 0.1%
-11.18447	1	< 0.1%
-11.17442	2	< 0.1%
-11.12442	1	< 0.1%
-11.1	1	< 0.1%
-11.09022	2	< 0.1%
-11.07447	1	< 0.1%
-11.05952	1	< 0.1%

Value	Count	Frequency (%)
42.16116354	1	< 0.1%
42.12416033	1	< 0.1%
42.02266235	1	< 0.1%
41.95165925	1	< 0.1%
41.93676939	1	< 0.1%
41.85961032	1	< 0.1%
41.83010052	1	< 0.1%
41.70123848	1	< 0.1%
41.36824861	1	< 0.1%
41.23725765	1	< 0.1%

Auto

Heatmap
Table

	ID	LC_HUMIDITY	LC_DWPTEMP	LC_n	LC_RAD	LC_RAININ	LC_DAILYRAIN	LC_WINDDIR	LC_WINDSPEED	LC_RAD60	LC_TEMP
ID	1.000	-0.064	0.009	0.053	0.001	-0.001	0.002	0.038	0.050	0.002	0.038
LC_HUMIDITY	-0.064	1.000	-0.169	0.016	-0.552	0.178	0.261	-0.048	-0.293	-0.607	-0.625
LC_DWPTEMP	0.009	-0.169	1.000	-0.005	0.225	0.043	0.079	-0.027	-0.007	0.241	0.840
LC_n	0.053	0.016	-0.005	1.000	-0.010	0.001	-0.005	-0.004	-0.017	-0.010	-0.008
LC_RAD	0.001	-0.552	0.225	-0.010	1.000	-0.053	-0.051	-0.001	0.350	0.954	0.482
LC_RAININ	-0.001	0.178	0.043	0.001	-0.053	1.000	0.359	-0.020	0.061	-0.048	-0.046
LC_DAILYRAIN	0.002	0.261	0.079	-0.005	-0.051	0.359	1.000	-0.066	0.136	-0.035	-0.068
LC_WINDDIR	0.038	-0.048	-0.027	-0.004	-0.001	-0.020	-0.066	1.000	-0.093	-0.002	0.012
LC_WINDSPEED	0.050	-0.293	-0.007	-0.017	0.350	0.061	0.136	-0.093	1.000	0.355	0.136
LC_RAD60	0.002	-0.607	0.241	-0.010	0.954	-0.048	-0.035	-0.002	0.355	1.000	0.522
LC_TEMP	0.038	-0.625	0.840	-0.008	0.482	-0.046	-0.068	0.012	0.136	0.522	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	DATEUTC	ID	LC_HUMIDITY	LC_DWPTEMP	LC_n	LC_WINDDIR	LC_WINDSPEED	LC_TEMP
0	2022-01-01 00:10:00	2	92	11.78	38	-169.0	0.43	13.048027
1	2022-01-01 00:20:00	2	92	11.73	37	-170.0	0.33	12.985849
2	2022-01-01 00:30:00	2	92	11.73	38	-167.0	0.46	12.950322
3	2022-01-01 00:40:00	2	92	11.72	37	-160.0	0.52	12.949550
4	2022-01-01 00:50:00	2	92	11.72	38	-166.0	0.51	12.952268
5	2022-01-01 01:00:00	2	92	11.72	37	-158.0	0.93	12.938731
6	2022-01-01 01:10:00	2	92	11.71	38	-161.0	0.54	12.949960
7	2022-01-01 01:20:00	2	91	11.62	37	-163.0	0.71	12.960576
8	2022-01-01 01:30:00	2	91	11.61	38	-160.0	0.54	12.980432
9	2022-01-01 01:40:00	2	91	11.61	37	-163.0	0.85	12.963181

	DATEUTC	ID	LC_HUMIDITY	LC_DWPTEMP	LC_n	LC_DAILYRAIN	LC_WINDDIR	LC_WINDSPEED	LC_TEMP
5546870	2022-12-31 22:30:00	138	53	6.49	32	0.002	-70.0	1.45	16.39359
5546871	2022-12-31 22:40:00	138	52	6.32	31	0.002	-52.0	1.23	16.48690
5546872	2022-12-31 22:50:00	138	51	6.30	32	0.002	-64.0	1.04	16.63222
5546873	2022-12-31 23:00:00	138	50	6.21	31	0.002	-61.0	1.43	16.71759
5546874	2022-12-31 23:10:00	138	50	6.16	32	0.002	-62.0	1.37	16.77703
5546875	2022-12-31 23:20:00	138	50	6.05	32	0.000	-49.0	0.67	16.76285
5546876	2022-12-31 23:30:00	138	50	6.00	32	0.000	-65.0	1.39	16.70722
5546877	2022-12-31 23:40:00	138	50	5.90	31	0.000	-41.0	1.25	16.60001
5546878	2022-12-31 23:50:00	138	50	5.89	32	0.000	-51.0	1.22	16.50053
5546879	2023-01-01 00:00:00	138	50	5.78	31	0.000	-53.0	1.08	16.37461

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample